package com.asiainfo.work.dao.second;

import com.asiainfo.work.entity.ZtBug;
import com.asiainfo.work.vo.BugClosedConsumeTimeStatistics;
import com.asiainfo.work.vo.BugClosedStatistics;
import com.asiainfo.work.vo.BugConsumeTimeStatistics;
import com.asiainfo.work.vo.BugStatistics;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * @author: bf
 * @date: 2021/1/6-17:58
 */
@Mapper
public interface ZtBugDao extends BaseMapper<ZtBug> {

    /**
     * 解决禅道bug消耗时间
     */
    List<BugConsumeTimeStatistics> queryConsumeBugTime(@Param("startTime") String startTime, @Param("endTime") String endTime,
            @Param("accountList") List<String> accountList, IPage<BugConsumeTimeStatistics> plusPage);

    /**
     *已经关闭的bug的消耗时间
     */
    List<BugClosedConsumeTimeStatistics> queryClosedBugConsumeTime(@Param("startTime") String startTime, @Param("endTime") String endTime,
            @Param("accountList") List<String> accountList, IPage<BugClosedConsumeTimeStatistics> plusPage);

    /**
     * 统计总bug数
     */
    List<BugStatistics> queryBugCount(@Param("startTime") String startTime, @Param("endTime") String endTime,
            @Param("accountList") List<String> accountList, IPage<BugStatistics> plusPage);

    /**
     * 统计已经关闭的bug数
     */
    List<BugClosedStatistics> queryBugClosedCount(@Param("startTime") String startTime, @Param("endTime") String endTime,
            @Param("accountList") List<String> accountList, IPage<BugClosedStatistics> plusPage);
}
